UPDATE  TB_RESULT_INPUT_CONDITION SET DATA_SOURCE=REPLACE(DATA_SOURCE,'+','||') WHERE DATA_SOURCE LIKE '%+%';
UPDATE  TB_RESULT_OUTPUT_CONTROL SET DATA_SOURCE=REPLACE(DATA_SOURCE,'+','||') WHERE DATA_SOURCE LIKE '%+%';
UPDATE  TB_TABLE_FIELD SET DATA_SOURCE=REPLACE(DATA_SOURCE,'+','||') WHERE DATA_SOURCE LIKE '%+%';
UPDATE  TB_RESULT_INPUT_CONDITION SET DATA_SOURCE=REPLACE(DATA_SOURCE,'@',':') WHERE DATA_SOURCE LIKE '%@%';
UPDATE  TB_RESULT_OUTPUT_CONTROL SET DATA_SOURCE=REPLACE(DATA_SOURCE,'@',':') WHERE DATA_SOURCE LIKE '%@%';
UPDATE  TB_TABLE_FIELD SET DATA_SOURCE=REPLACE(DATA_SOURCE,'@',':') WHERE DATA_SOURCE LIKE '%@%';

UPDATE TB_RESULT_INPUT_CONDITION SET DATA_SOURCE=REPLACE(DATA_SOURCE,'LEN(','LENGTH(') WHERE DATA_SOURCE LIKE '%LEN(%';
UPDATE TB_TABLE_FIELD SET DATA_SOURCE=REPLACE(DATA_SOURCE,'LEN(','LENGTH(') WHERE DATA_SOURCE LIKE '%LEN(%';

UPDATE TB_TABLE_FIELD SET DEFAULT_VALUE='SEQ_EXCH_DB_NO.NEXTVAL' WHERE TABLE_ID=9125 AND FIELD_ID=1;
UPDATE TB_TABLE_FIELD SET DEFAULT_VALUE='SEQ_EXCH_ID.NEXTVAL' WHERE TABLE_ID=9126 AND FIELD_ID=1;
UPDATE TB_TABLE_FIELD SET DEFAULT_VALUE='SEQ_INDEX_ID.NEXTVAL' WHERE TABLE_ID=9044 AND FIELD_ID=1;
UPDATE TB_TABLE_FIELD SET DEFAULT_VALUE='SEQ_INDEX_ID.NEXTVAL' WHERE TABLE_ID=9041 AND FIELD_ID=1;
UPDATE TB_TABLE_FIELD SET DEFAULT_VALUE='SEQ_INDEX_ID.NEXTVAL' WHERE TABLE_ID=9043 AND FIELD_ID=1;
UPDATE TB_TABLE_FIELD SET DEFAULT_VALUE='SEQ_INDEX_ID.NEXTVAL' WHERE TABLE_ID=9042 AND FIELD_ID=1;


commit;
